Upgrade your existing Tracking and Subscription databases for Outbound E-mail and Audience Manager by running a PowerShell script.
Before you begin
To upgrade the Tracking and Subscription database you need details of DBA and user credentials and the names of these databases.
Procedure
- Close all connections to your database server.
- If you have not done so already, make a back-up of your databases for safety reasons.
- Open Windows PowerShell from the Windows Start Menu.
- In PowerShell, depending on your database navigate to one of the following folders on the installation media:
- Database\MSSQL\
- Database\Oracle\
- Type the following command to upgrade your Tracking database:
& '.\Upgrade Outbound E-mail Tracking database.ps1'
- Type the following command to upgrade your Subscription database:
& '.\Upgrade Outbound E-mail Subscription Management database.ps1'
- Follow the instructions in the PowerShell console to upgrade the database. Repeat this procedure as needed.
Results
The database upgrade modifies the structure of the database tables. If you encounter problems during the upgrade, restore your backup and try again. If your second attempt fails as well, consult
SDLCustomer Support for assistance. Do not attempt to fix the database.
Note: After upgrading all your databases, make sure the size of your Contact extended detail fields in your Subscription database (on the Presentation Server) and Audience Manager database (on the Content Manager Server) are identical.